/**
 * 角色数据层
 * Author: 梦里小白龙 <jiangwenshu1990@126.com> <http://www.jz07.cn>
 */
var RolesSQL = {  
    insert:'INSERT INTO roles set ?', //添加数据
    getById:'SELECT * FROM roles WHERE id = ?',   //获取用户详情
    updateRoles:'UPDATE roles SET role_name = ? , stats = ?, role_txt = ? , role_module = ? WHERE id = ?',  //修改用户
    deleteRoles:'DELETE FROM roles WHERE id = ?',  //删除用户
    selectUserRole:'SELECT * FROM users WHERE role_id = ?',  //查询用户的角色ID
};
module.exports = RolesSQL;